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