UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zqe1expuB9kU86ZnvgSrSrZP2wzsKCJoMy3US/50UCY='
WHERE
key_id = '00b7398e3af91684f7a19bf8d632d50d554664d91814140fd7fc866612a147fa'
AND (
token = 'zqe1expuB9kU86ZnvgSrSrZP2wzsKCJoMy3US/50UCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)