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