UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TYqLczw0gmUnuErV2pyX8H2kVYcWJBad2D+Jp66Wb5Y='
WHERE
key_id = '4cf89b1052610cad596ea3b1fc49904ba104f0f88f5eecf325abc6edfb053f2a'
AND (
token = 'TYqLczw0gmUnuErV2pyX8H2kVYcWJBad2D+Jp66Wb5Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)