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