UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q7YoWTuhgx87B77eP4vf7hFZ18O8JLCe6aSPNMLaqsA='
WHERE
key_id = 'e65ff5a3a994ab0cd630427dee698dd88963a423fda69ca34f349b303de44c40'
AND (
token = 'q7YoWTuhgx87B77eP4vf7hFZ18O8JLCe6aSPNMLaqsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)