UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Fotg5d5TApRl2u5OxNPsG3cvJIRpYQBH7N0wIGgUolw='
WHERE
key_id = '9e4d240c9a179128902b7b4beade85946c244042da8bd1679e87fa10f27bc594'
AND (
token = 'Fotg5d5TApRl2u5OxNPsG3cvJIRpYQBH7N0wIGgUolw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)