SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '7d35f02786265a01663d748d26e026f448384ab44dc9af886cb14a2f84c87fd5' 
  AND token = 'r/u3N4DFU6XZVbpa1XYa3qsCm2RzcExxDnU/t7gXSic=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00042

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}