UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sgx4GV/peD/NMAqllErfz/4ACVW6lWj20DUqvt8rvgk='
WHERE
key_id = '04831c35d32ddba4a65559ba781a7e292e6044b513becdad788d6a6e93211d25'
AND (
token = 'sgx4GV/peD/NMAqllErfz/4ACVW6lWj20DUqvt8rvgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)