UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2B9MjSRPSU73AMi9KMZn8oEljiqNzcdYvJQRPBLIufo='
WHERE
key_id = 'c71a7acada44a6b21a2a0fbf5acdf2a95196d39bbc826ff16ade394817e855a3'
AND (
token = '2B9MjSRPSU73AMi9KMZn8oEljiqNzcdYvJQRPBLIufo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)