UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zjBQQfT9s921aRdztD4HEKLNj+/ru5E0/oGAoht8s9o='
WHERE
key_id = 'c9fed27e5c84e81c1983f72bdb0570ddd8de2f89cc01e6e26be774e75d644e5f'
AND (
token = 'zjBQQfT9s921aRdztD4HEKLNj+/ru5E0/oGAoht8s9o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)