UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QcrzXfZgzHILY5QGKShrrEIZUFP/6BBz95L4HOHnvwU='
WHERE
key_id = '8bc4ad727a866d80c807fa26b370842e6fc32562fe14e4c1146af7d41d4fc7ea'
AND (
token = 'QcrzXfZgzHILY5QGKShrrEIZUFP/6BBz95L4HOHnvwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)