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