UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XL/jdC51s6cdyY0x6StL+E6upEaedOuGlSf/yIIp2DQ='
WHERE
key_id = '783fa1a781e7e0cc89f12e5fc381e4687eb30412139a0a16121a82fd37ec2ac4'
AND (
token = 'XL/jdC51s6cdyY0x6StL+E6upEaedOuGlSf/yIIp2DQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)