UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9yIHPj8QBxvXxTD8SF/jvFgulZviHAM/mKoAjuOOAm8='
WHERE
key_id = '3d825c5ce13f69196785f9c5473cc90a4cce92385d5b3de7e30dae9a4ca9055e'
AND (
token = '9yIHPj8QBxvXxTD8SF/jvFgulZviHAM/mKoAjuOOAm8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)