UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Mz5JFiSVFvP4ddi+A/owt0m0adbceqjWvAM53klVR/U='
WHERE
key_id = 'c01478d419b1072a78f45b88b08c21ba2c316f88f8d18dda3ec3c918046c1bc4'
AND (
token = 'Mz5JFiSVFvP4ddi+A/owt0m0adbceqjWvAM53klVR/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)