UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Kx0ys1ye4b4bJosdZam+CXFRIiN7Wn9d7V45zBC+55s='
WHERE
key_id = 'f9e86dc6a2049be947a0d77783e711468e0de27bc465944c49b08c409827841c'
AND (
token = 'Kx0ys1ye4b4bJosdZam+CXFRIiN7Wn9d7V45zBC+55s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)