UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7xgSZc5/CFeMH9vP1uhYPv+sQAtEXVOl1h5Hf0dBRAk='
WHERE
key_id = '9c49dbbd27e0544a88838b6c29c0e7c7826a87b2057d6c2bfd5f1a7771a18b5d'
AND (
token = '7xgSZc5/CFeMH9vP1uhYPv+sQAtEXVOl1h5Hf0dBRAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)