UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Te1Bir56zJz6SUT4nGZLTXf/1dnvcBTXO8q9nIwZYs='
WHERE
key_id = '47cb7876bda87eb21f0141dfbf6b6409f9ab432059b2e9728582717467c3e26f'
AND (
token = '9Te1Bir56zJz6SUT4nGZLTXf/1dnvcBTXO8q9nIwZYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)