UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rq8pl5FMi/gjQ7rZOBG5TVVMkSGCTr4OjO6fmT96vWE='
WHERE
key_id = 'a1b19bfd06f151e6305121f88a5e1ac443c32a9032849ca0f2ea7ea948ce5109'
AND (
token = 'rq8pl5FMi/gjQ7rZOBG5TVVMkSGCTr4OjO6fmT96vWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)