UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7xy6tKYGNBFUErV8b4yAwW8dHf9cSM6AWpNVlsBnhYw='
WHERE
key_id = '8f7f486bf079e3ff3fb7a3357e0e3058ff708c9a9d38f62de0956a6daafcbde0'
AND (
token = '7xy6tKYGNBFUErV8b4yAwW8dHf9cSM6AWpNVlsBnhYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)