UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lMfKobpA33HP+FWuAQIjI6+z21X0NwNLU8+LzOghWbs='
WHERE
key_id = 'd9e605604ec8cc99ed375e45a5652a80b14a860e1b85e18ea818e2c383604f87'
AND (
token = 'lMfKobpA33HP+FWuAQIjI6+z21X0NwNLU8+LzOghWbs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)