UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgf3+SW1ls+GiBpeCD7IiLznenzWk+AKh2/svYRS70M='
WHERE
key_id = '0e9050caed1404e92853f8a714486ca07f7b7c9a39e3cc1ea027b068c5701b95'
AND (
token = 'zgf3+SW1ls+GiBpeCD7IiLznenzWk+AKh2/svYRS70M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)