UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bY6VCR+LGST6/7MmX5hKOwVn8AR+lmIclYhENP9lc9g='
WHERE
key_id = '9dbeaa6b2a7f76307ffcc052a5a15f3aee7df1eda03a698d0594b650105124f4'
AND (
token = 'bY6VCR+LGST6/7MmX5hKOwVn8AR+lmIclYhENP9lc9g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)