UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kiIYcyg77dagm2QE9FI8Ne+VhhJxXdOnC+eLSSm+UnI='
WHERE
key_id = 'f1b1c5e8e9732922efa4dabc46b127c5f0654bcb05f76e598484abe4ebadeb60'
AND (
token = 'kiIYcyg77dagm2QE9FI8Ne+VhhJxXdOnC+eLSSm+UnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)