UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZKvA6RzFSTXAszrf3t5FzDoDwypkAUYOqnduJF4jvxY='
WHERE
key_id = '9727bf63b9f0e2ac7784d6e4ca6fc14ecc00be040b87daf6f36a7d2ed7656802'
AND (
token = 'ZKvA6RzFSTXAszrf3t5FzDoDwypkAUYOqnduJF4jvxY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)