UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FXoDlXAdwGxJvVyIx8gAaJ3N2gvK9/5vbNVeXY/m7/U='
WHERE
key_id = 'f67d68bade4b1f6aa8643def9d65d6e0a8a95b1d36abbf46744e936055830767'
AND (
token = 'FXoDlXAdwGxJvVyIx8gAaJ3N2gvK9/5vbNVeXY/m7/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)