UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oGP1/j/PNxNOusX8egDRqquavxYGSjMmSATIzGLo2os='
WHERE
key_id = 'f9715ab8bc3dca223179d01e7b56787482e47490f8ef96be755582af0ef28d0a'
AND (
token = 'oGP1/j/PNxNOusX8egDRqquavxYGSjMmSATIzGLo2os='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)