UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c4UB4aacBPjS+z96fXcB+BfBIN2a+lkG/u6Fu8Zddyw='
WHERE
key_id = '12950487a048f48301a58891738ad974aeee9975065b6ba42ee48cdc0b1b0d64'
AND (
token = 'c4UB4aacBPjS+z96fXcB+BfBIN2a+lkG/u6Fu8Zddyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)