UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4x0gtVZ5kbJMKUckEeENWgbUlPJVjYuq2HtVcu33xws='
WHERE
key_id = '2ac9a5fdef322de136f18501fe8fc7a9cd6b6becefc4593a1cdca5371145054a'
AND (
token = '4x0gtVZ5kbJMKUckEeENWgbUlPJVjYuq2HtVcu33xws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)