UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'whfJuACKCcWBnllfGHIT1HZjKkTQLqfsJIaMAMEQg98='
WHERE
key_id = '24924f35f02bbaa92ef0ed418910469eb8ef1a13ee1c524ac6a17de2b6bf9060'
AND (
token = 'whfJuACKCcWBnllfGHIT1HZjKkTQLqfsJIaMAMEQg98='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)