UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FhghvqKp1nyzDDU3PgvtCzlWcobkwI7hpOqiX1GwPlU='
WHERE
key_id = 'e87c3e9ca860e33d6f4379d81b69b87a5bf47e89af754131caf96a6966a704e2'
AND (
token = 'FhghvqKp1nyzDDU3PgvtCzlWcobkwI7hpOqiX1GwPlU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)