UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a449HLkdEOdbBXoIboT1J4SJRbR1qxsYCCEGfFQXXu4='
WHERE
key_id = 'a3f0e832b96ed65c8e9c8be1f788927f91001da2ab4aa67d9d171809eb4cf830'
AND (
token = 'a449HLkdEOdbBXoIboT1J4SJRbR1qxsYCCEGfFQXXu4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)