UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Gtu4JOa4cu5DORA2YgIyMCrqDouB5AZc5iZ9Y8Mbxk='
WHERE
key_id = 'f5022957e81a83b21f90530bd0ba5e11b1c86581b1750eb0aeb524c88f8a2466'
AND (
token = '5Gtu4JOa4cu5DORA2YgIyMCrqDouB5AZc5iZ9Y8Mbxk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)